Ideal Strategy to Improve Datawarehouse Performance
نویسنده
چکیده
Data warehouse is set up for the benefits of business analysts and executives across all functional areas. The primary goal of data warehouse is to free the information locked up in the operational database so that decision makers and business analyst can make queries, analysis and planning regardless of the data changes in operational database. Data analysis in a large database requires some innovative techniques; there should be some new methods and procedures to look at the data with different angles. While executing adhoc queries over a large database degrade the query performance at considerable level because query will have to go through from large volume of data after making lot of joins. Moreover, as the number of queries is large, therefore, in certain cases there is reasonable probability that same query submitted by the one or multiple users at different times. Each time when query is executed, all the data of warehouse is analyzed to generate the result of that query. In this paper we purpose an ideal approach which definitely minimizes response time and improves the efficiency of data warehouse overall, particularly when data warehouse is updated at regular interval. This approach has been validated by Formal Method. Keywords-Data Warehouse; Perfomance; Formal Method
منابع مشابه
Using contingency approach to improve firms’ financial performance forecasts
One of the challenging issues for investors and professionals is appropriate models to evaluate financial situation of the firms. In this regard, many models have been extracted by researchers using different financial ratios to resolve these issues. However, choosing a model based on the conditions and users’ needs is complex. The main objective of this study is to identify the effect of conti...
متن کاملThe Evaluation method of HVAC System’s operation performance based on Energy Flow Analysis and DEA
An energy flow model of an airport terminal’s HVAC system is established in this paper. Based on energy flow model, the exergy efficiency, exergy loss and exergy cost distribution ratio of each component are calculated and analyzed by the energy flow model. Optimization method and exergy balance equations are used to calculate the lowest exergy loss of HVAC system under different operation cond...
متن کاملA survey of query recommendation techniques for data warehouse exploration
Lots of data are gathered in datawarehouses that are navigated and explored for analytical purposes. Only recently has the problem of recommending a datawarehouse query to a datawarehouse user attracted attention. In this paper, we propose a simple formal framework for expressing datawarehouse query recommendations. We propose to see the problem of recommending a datawarehouse query for explora...
متن کاملMultidimensional Datawarehouse with Combination Formula
Spits Warnars Harco Leslie Hendric (BLLES) Budi Luhur Learning Solution Budi Luhur University Jl. Petukangan Utara, Kebayoran Lama, Jakarta Selatan 12260, Indonesia [email protected] ABSTRACT Multidimensional in data warehouse is a compulsion and become the most important for information delivery, without multidimensional datawarehouse is incomplete. Multidimensional give the able to analyze busin...
متن کاملDESIGN AND DEVELOPMENT OF THE STRATEGY TO IMPROVE PATIENT SATISFACTION IN A HOSPITAL SETTING
Attempts made in order to improve management tools of performance showing the importance of customer satisfaction in determining the organizations’ success in profitability and business. The main objective of this study was to develop appropriate strategies to improve patient satisfaction in Hospital. The research was a descriptive-practical one. Data was collected through a brainstorming...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2010